package com.dldata.display.repository.System;

import com.dldata.display.entity.SysDtwyZbbEntity;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import java.sql.Timestamp;
import java.util.List;

/**
 * Created by 吴岳峰 on 2017/07/11.
 */
public interface SysDtwyZbbDao extends PagingAndSortingRepository<SysDtwyZbbEntity,String>,JpaSpecificationExecutor<SysDtwyZbbEntity> {

    @Query("select e from SysDtwyZbbEntity e where e.rq between ?1 and ?2 and e.ksId like ?3 order by e.rq")
    public List<SysDtwyZbbEntity> findByKsMonth(Timestamp s, Timestamp e, String ks);
}
